会计规则

概述

重启,重启,重启

账套/账簿

单账套/多账套

多账套实例1

多账套实例2

实体的账套设置

账户结构

关于平衡段
维度的组织指定

账户组合

编辑科目时,系统同时更新账户组合值

导入科目无法自动更新账户组合的描述和名称
select a.Combination ,a.Description, b.value, b.name, strpos(a.Combination, b.value)  from C_ValidCombination a
join C_ElementValue b on a.Account_ID = C_ElementValue_ID where strpos(a.Combination, b.value) = 0

导入科目后更新账户组合(需根据自己维度更改字符串)
update C_ValidCombination a 
set Combination= '*-' || b.value || '-_-_-_' , description =  '*-' || b.name || '-_-_-_' from 
 C_ElementValue b where a.Account_ID = b.C_ElementValue_ID and strpos(a.Combination, b.value) = 0

更新事务表的科目id
update Fact_Acct set Account_ID =1001058  where Account_ID = 1000493;
update Fact_Acct_Summary set Account_ID =1001058  where Account_ID = 1000493;
update Fact_Reconciliation set fact_acct_id =1001058  where fact_acct_id = 1000493;
update GL_JournalLine set Account_ID =1001058  where Account_ID = 1000493;
update GL_JournalLine set c_validcombination_id =1000555  where c_validcombination_id = 1000551;

重新登帐

几个选项

新建账套